<?php
/**************************************************************************************************
|
| AudioShare - Audio Sharing Script
| http://www.audiosharescript.com
| webmaster@audiosharescript.com
| Version: 2.0
|
|**************************************************************************************************
|
| By using this software you agree that you have read and acknowledged our End-User License 
| Agreement available at http://www.audiosharescript.com/eula.html and to be bound by it.
|
| Copyright (c) 2009 AudioShareScript.com. All rights reserved.
|**************************************************************************************************/

include("../include/config.php");
include_once("../include/functions/import.php");
verify_login_admin();
$adminurl = $config['adminurl'];

//DELETE PLAYLIST
if($_REQUEST[delete]=="1")
{
	$DPLAYLISTID = intval($_REQUEST['PLAYLISTID']);
	
	## DELETE AUDIOS FOR THAT PLAYLIST
		$query="DELETE FROM playlist_audios WHERE PLAYLISTID='".mysql_real_escape_string($DPLAYLISTID)."'";
		$results = $conn->execute($query);
	## DELETE AUDIOS FOR THAT PLAYLIST END
	
	## DELETE THAT PLAYLIST START
		$query="DELETE FROM playlists WHERE PLAYLISTID='".mysql_real_escape_string($DPLAYLISTID)."'";
		$results = $conn->execute($query);
	## DELETE THAT PLAYLIST ENDS
	
	$message = "Playlist Successfully Deleted.";
	Stemplate::assign('message',$message);
}
//DELETE PLAYLIST END

/*if(!empty($_POST)){
	echo "<pre>";
	print_r($_POST);
}*/

//FEATURED
if($_POST['fsub']=="1")
{
	$FPLAYLISTID = $_POST['FPLAYLISTID'];
	$fval = $_POST['fval'];
	if($fval == "0")
	{
		$fval2 = "1";
	}
	else
	{
		$fval2 = "0";
	}
	$sql="UPDATE playlists SET featured='".intval($fval2)."' WHERE PLAYLISTID='".mysql_real_escape_string($FPLAYLISTID)."'";
	$conn->Execute($sql);
}
//FEATURED

/*
//ACTIVE
if($_POST['asub']=="1")
{
	$AUSERID = $_POST['AUSERID'];
	$aval = $_POST['aval'];
	if($aval == "0")
	{
		$aval2 = "1";
	}
	else
	{
		$aval2 = "0";
	}
	$sql="UPDATE members SET status='".intval($aval2)."' WHERE USERID='".mysql_real_escape_string($AUSERID)."'";
	$conn->Execute($sql);
}
//ACTIVE
*/

//VERIFIED
if($_POST['vsub']=="1")
{
	$VUSERID = $_POST['VUSERID'];
	$vval = $_POST['vval'];
	if($vval == "0")
	{
		$vval2 = "1";
	}
	else
	{
		$vval2 = "0";
	}
	$sql="UPDATE members SET verified='".intval($vval2)."' WHERE USERID='".mysql_real_escape_string($VUSERID)."'";
	$conn->Execute($sql);
}
//VERIFIED

if($_REQUEST['sortby']=="playlist_title")
{
	$sortby = "playlist_title";
	$sort =" order by playlist_title";
	$add1 = "&sortby=playlist_title";
}
elseif($_REQUEST['sortby']=="username")
{
	$sortby = "username";
	$sort =" order by username";
	$add1 = "&sortby=username";
}
/*elseif($_REQUEST['sortby']=="verified")
{
	$sortby = "verified";
	$sort =" order by verified";
	$add1 = "&sortby=verified";
}*/
elseif($_REQUEST['sortby']=="date_added")
{
	$sortby = "date_added";
	$sort =" order by date_added";
	$add1 = "&sortby=date_added";
}
/*elseif($_REQUEST['sortby']=="familyfilter")
{
	$sortby = "familyfilter";
	$sort =" order by familyfilter";
	$add1 = "&sortby=familyfilter";
}*/
elseif($_REQUEST['sortby']=="featured")
{
	$sortby = "featured";
	$sort =" order by featured";
	$add1 = "&sortby=featured";
}
/*elseif($_REQUEST['sortby']=="status")
{
	$sortby = "status";
	$sort =" order by status";
	$add1 = "&sortby=status";
}*/
else
{
	$sortby = "PLAYLISTID";
	$sort =" order by PLAYLISTID";
	$add1 = "&sortby=PLAYLISTID";
}

if($_REQUEST['sorthow']=="desc")
{
	$sorthow ="desc";
	$add1 .= "&sorthow=desc";
}
else
{
	$sorthow ="asc";
	$add1 .= "&sorthow=asc";
}

//Search
$fromid = intval($_REQUEST['fromid']);
$toid = intval($_REQUEST['toid']);
$playlist_title = $_REQUEST['playlist_title'];
$username = $_REQUEST['username'];
$featured = $_REQUEST['featured'];

$add1 .= "&fromid=$fromid&toid=$toid&playlist_title=$playlist_title&username=$username&featured=$featured";

if($_POST['submitform'] == "1" || ($_REQUEST['fromid']!="" || $toid>0 || $playlist_title!="" || $username!=""  || $featured!=""))
{
	if($fromid > 0)
	{
		$addtosql = " AND p.PLAYLISTID>='".mysql_real_escape_string($fromid)."'";
		Stemplate::assign('fromid',$fromid);
	}
	else
	{
		$addtosql = " AND p.PLAYLISTID>'".mysql_real_escape_string($fromid)."'";
	}
	if($toid > 0)
	{
		$addtosql .= " AND p.PLAYLISTID<='".mysql_real_escape_string($toid)."'";
		Stemplate::assign('toid',$toid);
	}
	if($username != "")
	{
		$addtosql .= "AND m.username like'%".mysql_real_escape_string($username)."%'";
		Stemplate::assign('username',$username);
	}
	if($playlist_title != "")
	{
		$addtosql .= " AND playlist_title like'%".mysql_real_escape_string($playlist_title)."%'";
		Stemplate::assign('playlist_title',$playlist_title);
	}
	/*if($verified != "")
	{
		$addtosql .= "AND verified='1'";
		Stemplate::assign('verified',$verified);
	}
	if($familyfilter != "")
	{
		$addtosql .= "AND familyfilter='1'";
		Stemplate::assign('familyfilter',$familyfilter);
	}*/
	if($featured != "")
	{
		$addtosql .= "AND p.featured='1'";
		Stemplate::assign('featured',$featured);
	}
	/*if($status != "")
	{
		$addtosql .= "AND status='1'";
		Stemplate::assign('status',$status);
	}*/
	Stemplate::assign('search',"1");
}
//Search End

$page = intval($_REQUEST['page']);
if($page=="")
{
	$page = "1";
}
$currentpage = $page;

if ($page >=2)
{
	$pagingstart = ($page-1)*$config['items_per_page'];
}
else
{
	$pagingstart = "0";
}

//$queryselected = "select USERID from members $addtosql $sort $sorthow limit $config[maximum_results]";

$queryselected="select p.PLAYLISTID from playlists p left join members m on (m.USERID=p.USERID) where m.status='1'";
$query2 = "select p.PLAYLISTID,m.USERID,m.username,p.playlist_title,p.date_added,p.featured  from playlists p left join members m on (m.USERID=p.USERID) where m.status='1' $addtosql $sort $sorthow limit $pagingstart, $config[items_per_page]";
$executequeryselected = $conn->Execute($queryselected);
$totalvideos = $executequeryselected->rowcount();	

if ($totalvideos > 0)
{
	if($totalvideos<=$config[maximum_results])
	{
		$total = $totalvideos;
	}
	else
	{
		$total = $config[maximum_results];
	}
	$toppage = ceil($total/$config[items_per_page]);
	if($toppage==0)
	{
		$xpage=$toppage+1;
	}
	else
	{
		$xpage = $toppage;
	}

	$executequery2 = $conn->Execute($query2);	
	$results = $executequery2->getrows();
	$beginning=$pagingstart+1;
	$ending=$pagingstart+$executequery2->recordcount();
	$pagelinks="";
	$k=1;
	$theprevpage=$currentpage-1;
	$thenextpage=$currentpage+1;
	if ($currentpage > 0)
	{	
		if($currentpage > 1) 
		{
			$pagelinks.="<a href='$adminurl/playlists_manage.php?page=1$add1' title='first page'>First</a>&nbsp;";
			$pagelinks.="<a href='$adminurl/playlists_manage.php?page=$theprevpage$add1'>Previous</a>&nbsp;";
		};
		$counter=0;
		$lowercount = $currentpage-5;
		if ($lowercount <= 0) $lowercount = 1;
		while ($lowercount < $currentpage)
		{
			$pagelinks.="<a href='$adminurl/playlists_manage.php?page=$lowercount$add1'>$lowercount</a>&nbsp;";
			$lowercount++;
			$counter++;
		}
		$pagelinks.=$currentpage."&nbsp;";
		$uppercounter = $currentpage+1;
		while (($uppercounter < $currentpage+10-$counter) && ($uppercounter<=$toppage))
		{
			$pagelinks.="<a href='$adminurl/playlists_manage.php?page=$uppercounter$add1'>$uppercounter</a>&nbsp;";
			$uppercounter++;
		}
		if($currentpage < $toppage) 
		{
			$pagelinks.="<a href='$adminurl/playlists_manage.php?page=$thenextpage$add1'>Next</a>&nbsp;";
			$pagelinks.="<a href='$adminurl/playlists_manage.php?page=$toppage$add1' title='last page'>Last</a>&nbsp;";
		};
	}
}
else
{
	$error = "Sorry, no playlists were found.";
}

$mainmenu = "13";
$submenu = "1";

Stemplate::assign('mainmenu',$mainmenu);
Stemplate::assign('submenu',$submenu);
Stemplate::assign('sorthow',$sorthow);
Stemplate::assign('sortby',$sortby);
Stemplate::assign('currentpage',$currentpage);
STemplate::display("administrator/global_header.tpl");
STemplate::assign('beginning',$beginning);
STemplate::assign('ending',$ending);
STemplate::assign('pagelinks',$pagelinks);
STemplate::assign('total',$total+0);
STemplate::assign('results',$results);
Stemplate::assign('error',$error);
STemplate::display("administrator/playlists_manage.tpl");
STemplate::display("administrator/global_footer.tpl");
?>